﻿using System.Data;

namespace DAL
{
    public static class DalReportSell
    {
        private static readonly clsConnect Cls = new clsConnect();
        #region[Get-Data]
        public static DataTable GetReportSell(int ID_Sell)
        {
            Cls.CreateNewSqlCommand();
            Cls.AddParameter("@ID_Sell", ID_Sell);
            return Cls.GetData("sp_Report_Sell");
        }
        public static DataTable GetReportSellOrder(int ID_Sell)
        {
            Cls.CreateNewSqlCommand();
            Cls.AddParameter("@ID_Sell", ID_Sell);
            return Cls.GetData("sp_ReportOrder_Sell");
        }
        public static DataTable GetReportBuy(int Order_Buy_Id)
        {
            Cls.CreateNewSqlCommand();
            Cls.AddParameter("@Order_Buy_Id", Order_Buy_Id);
            return Cls.GetData("sp_ReportBuy");
        }
        public static DataTable GetReportReceipt(int ID)
        {
            Cls.CreateNewSqlCommand();
            Cls.AddParameter("@ID", ID);
            return Cls.GetData("sp_ReportReceipt");
        }
        public static DataTable GetReportExpenditure(int ID)
        {
            Cls.CreateNewSqlCommand();
            Cls.AddParameter("@ID", ID);
            return Cls.GetData("sp_ReportExpenditure_Get");
        }
        public static DataTable GetReportProposed(int Proposed_ID)
        {
            Cls.CreateNewSqlCommand();
            Cls.AddParameter("@Proposed_ID", Proposed_ID);
            return Cls.GetData("sp_ReportProposed_Get");
        }
        public static DataTable GetReportImportGet(int Import_ID)
        {
            Cls.CreateNewSqlCommand();
            Cls.AddParameter("@Import_ID", Import_ID);
            return Cls.GetData("sp_ReportImportGet");
        }
        #endregion
    }
}